IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_Event')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_Event
  END
  
CREATE TABLE [dbo].[CGO_Event]
(
[EventID] [int] NOT NULL IDENTITY(1, 1),
[PortalID] [int] NOT NULL,
[DateBegin] [datetime] NOT NULL,
[DateEnd] [datetime] NOT NULL,
[Name] [nvarchar] (100) NOT NULL,
[Description] [ntext] NULL,
[MaxEnrollment] [int] NULL,
[EnrollFee] [money] NULL,
[EnrollType] [nvarchar] (10) NOT NULL,
[ImageURL] [nvarchar] (100) NULL,
[ImageType] [varchar] (1) NULL,
[ImageWidth] [int] NULL,
[ImageHeight] [int] NULL,
[Status] [int] NOT NULL,
[Category] [int] NULL,
[ImageDisplay] [bit] NOT NULL,
[Signups] [bit] NOT NULL,
[AllDayEvent] [bit] NOT NULL,
[Approved] [bit] NOT NULL,
[CreatedByID] [int] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[LastUpdatedID] [int] NOT NULL,
[LastUpdateDate] [datetime] NOT NULL
)
GO

ALTER TABLE [dbo].[CGO_Event] ADD CONSTRAINT [PK_CGO_Events] PRIMARY KEY CLUSTERED  ([EventID]) WITH (FILLFACTOR=90) ON [PRIMARY]